﻿
CREATE proc [log].[GetNotizUserSentMails]
@UserID int,
@NotizID int
as
begin
	declare @ret bit = 0
	if exists(
		select	* 
		from	[log].[hlpNotizUserSentMails] n
		where	n.UserID = @UserID
				and n.NotizID = @NotizID
		)
	begin
		set @ret = 1
	end

	select @ret 'Sent'

	return 0
end
